Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 65993 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 11.1 MiB |
| Average record size in memory | 176.2 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 10 |
| Categorical | 1 |
| Unsupported | 3 |
Current is highly correlated with Voltage and 2 other fields | High correlation |
Voltage is highly correlated with Current and 2 other fields | High correlation |
Power is highly correlated with Current and 2 other fields | High correlation |
Elevation is highly correlated with Odometer | High correlation |
Odometer is highly correlated with Elevation | High correlation |
Acceleration is highly correlated with Current and 2 other fields | High correlation |
Grade is highly correlated with Angle | High correlation |
Angle is highly correlated with Grade | High correlation |
Current is highly correlated with Voltage and 2 other fields | High correlation |
Voltage is highly correlated with Current and 1 other fields | High correlation |
Power is highly correlated with Current and 2 other fields | High correlation |
Acceleration is highly correlated with Current and 1 other fields | High correlation |
Grade is highly correlated with Angle | High correlation |
Angle is highly correlated with Grade | High correlation |
Current is highly correlated with Power and 1 other fields | High correlation |
Power is highly correlated with Current and 1 other fields | High correlation |
Acceleration is highly correlated with Current and 1 other fields | High correlation |
Grade is highly correlated with Angle | High correlation |
Angle is highly correlated with Grade | High correlation |
Current is highly correlated with Voltage and 3 other fields | High correlation |
Voltage is highly correlated with Current and 3 other fields | High correlation |
Power is highly correlated with Current and 3 other fields | High correlation |
Elevation is highly correlated with Odometer and 2 other fields | High correlation |
Speed is highly correlated with Current and 1 other fields | High correlation |
Odometer is highly correlated with Voltage and 3 other fields | High correlation |
Temperature is highly correlated with Elevation and 2 other fields | High correlation |
Acceleration is highly correlated with Current and 2 other fields | High correlation |
Grade is highly correlated with Angle | High correlation |
Angle is highly correlated with Grade | High correlation |
Day is highly correlated with Elevation and 2 other fields | High correlation |
DateTime has unique values | Unique |
Hour is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
30Min is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
1Min is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Speed has 1133 (1.7%) zeros | Zeros |
Acceleration has 879 (1.3%) zeros | Zeros |
Reproduction
| Analysis started | 2022-03-23 18:38:32.254059 |
|---|---|
| Analysis finished | 2022-03-23 18:39:00.071422 |
| Duration | 27.82 seconds |
| Software version | pandas-profiling v3.1.1 |
| Download configuration | config.json |
| Distinct | 65993 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 515.7 KiB |
| Minimum | 2020-08-03 08:56:49 |
|---|---|
| Maximum | 2020-08-07 22:03:59 |
Histogram with fixed size bins (bins=50)
| Distinct | 7767 |
|---|---|
| Distinct (%) | 11.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.13724031 |
| Minimum | -444.3 |
|---|---|
| Maximum | 506.2 |
| Zeros | 19 |
| Zeros (%) | < 0.1% |
| Negative | 26209 |
| Negative (%) | 39.7% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | -444.3 |
|---|---|
| 5-th percentile | -209 |
| Q1 | -73.5 |
| median | 31.3 |
| Q3 | 136 |
| 95-th percentile | 302.34 |
| Maximum | 506.2 |
| Range | 950.5 |
| Interquartile range (IQR) | 209.5 |
Descriptive statistics
| Standard deviation | 158.7174993 |
|---|---|
| Coefficient of variation (CV) | 4.789701792 |
| Kurtosis | -0.2333289263 |
| Mean | 33.13724031 |
| Median Absolute Deviation (MAD) | 104.7 |
| Skewness | 0.0041588751 |
| Sum | 2186825.9 |
| Variance | 25191.24459 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4.3 | 80 | 0.1% |
| 4.2 | 76 | 0.1% |
| 4.1 | 76 | 0.1% |
| 3.4 | 57 | 0.1% |
| 3.6 | 56 | 0.1% |
| 3.9 | 55 | 0.1% |
| 4.4 | 54 | 0.1% |
| 3.5 | 51 | 0.1% |
| 4.5 | 50 | 0.1% |
| 4 | 50 | 0.1% |
| Other values (7757) | 65388 |
| Value | Count | Frequency (%) |
| -444.3 | 1 | |
| -442.7 | 1 | |
| -435.3 | 1 | |
| -434.2 | 1 | |
| -432.7 | 1 | |
| -427.5 | 1 | |
| -426.5 | 1 | |
| -425.3 | 1 | |
| -425.2 | 1 | |
| -424.7 | 1 |
| Value | Count | Frequency (%) |
| 506.2 | 1 | |
| 494.5 | 1 | |
| 493 | 1 | |
| 492.4 | 1 | |
| 492.3 | 1 | |
| 483.9 | 1 | |
| 467.9 | 1 | |
| 464.6 | 1 | |
| 463.6 | 1 | |
| 463 | 1 |
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 507.5707272 |
| Minimum | 483 |
|---|---|
| Maximum | 523 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | 483 |
|---|---|
| 5-th percentile | 497 |
| Q1 | 504 |
| median | 508 |
| Q3 | 512 |
| 95-th percentile | 517 |
| Maximum | 523 |
| Range | 40 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.965492725 |
|---|---|
| Coefficient of variation (CV) | 0.01175302752 |
| Kurtosis | 0.1528696565 |
| Mean | 507.5707272 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -0.4224768134 |
| Sum | 33496115 |
| Variance | 35.58710345 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=41)
| Value | Count | Frequency (%) |
| 510 | 5239 | 7.9% |
| 508 | 4942 | 7.5% |
| 512 | 4632 | 7.0% |
| 506 | 4361 | 6.6% |
| 509 | 3957 | 6.0% |
| 511 | 3608 | 5.5% |
| 504 | 3580 | 5.4% |
| 507 | 3549 | 5.4% |
| 505 | 3207 | 4.9% |
| 514 | 2896 | 4.4% |
| Other values (31) | 26022 |
| Value | Count | Frequency (%) |
| 483 | 4 | < 0.1% |
| 484 | 35 | 0.1% |
| 485 | 31 | < 0.1% |
| 486 | 51 | 0.1% |
| 487 | 49 | 0.1% |
| 488 | 59 | 0.1% |
| 489 | 74 | 0.1% |
| 490 | 98 | |
| 491 | 121 | |
| 492 | 241 |
| Value | Count | Frequency (%) |
| 523 | 7 | < 0.1% |
| 522 | 94 | 0.1% |
| 521 | 125 | 0.2% |
| 520 | 265 | 0.4% |
| 519 | 455 | 0.7% |
| 518 | 1279 | |
| 517 | 1320 | |
| 516 | 2249 | |
| 515 | 2046 | |
| 514 | 2896 |
| Distinct | 45791 |
|---|---|
| Distinct (%) | 69.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.28955887 |
| Minimum | -223.3089 |
|---|---|
| Maximum | 253.6062 |
| Zeros | 19 |
| Zeros (%) | < 0.1% |
| Negative | 26209 |
| Negative (%) | 39.7% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | -223.3089 |
|---|---|
| 5-th percentile | -107.01856 |
| Q1 | -37.485 |
| median | 15.9317 |
| Q3 | 68.6907 |
| 95-th percentile | 151.66342 |
| Maximum | 253.6062 |
| Range | 476.9151 |
| Interquartile range (IQR) | 106.1757 |
Descriptive statistics
| Standard deviation | 80.35341202 |
|---|---|
| Coefficient of variation (CV) | 4.932816946 |
| Kurtosis | -0.2344643565 |
| Mean | 16.28955887 |
| Median Absolute Deviation (MAD) | 53.0659 |
| Skewness | -0.02900757536 |
| Sum | 1074996.858 |
| Variance | 6456.670823 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.142 | 22 | < 0.1% |
| 0 | 19 | < 0.1% |
| 2.1378 | 15 | < 0.1% |
| 2.091 | 14 | < 0.1% |
| 2.1887 | 13 | < 0.1% |
| 2.0951 | 13 | < 0.1% |
| 1.854 | 12 | < 0.1% |
| 2.193 | 11 | < 0.1% |
| 10.3124 | 11 | < 0.1% |
| 2.244 | 10 | < 0.1% |
| Other values (45781) | 65853 |
| Value | Count | Frequency (%) |
| -223.3089 | 1 | |
| -223.1208 | 1 | |
| -222.7446 | 1 | |
| -222.4078 | 1 | |
| -222.15 | 1 | |
| -219.221 | 1 | |
| -218.88 | 1 | |
| -217.4464 | 1 | |
| -216.9594 | 1 | |
| -216.394 | 1 |
| Value | Count | Frequency (%) |
| 253.6062 | 1 | |
| 247.486 | 1 | |
| 247.25 | 1 | |
| 246.2 | 1 | |
| 243.6885 | 1 | |
| 242.9178 | 1 | |
| 234.4179 | 1 | |
| 231.8 | 1 | |
| 231.795 | 1 | |
| 231.2352 | 1 |
| Distinct | 985 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.23586744 |
| Minimum | 30.8 |
|---|---|
| Maximum | 134.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | 30.8 |
|---|---|
| 5-th percentile | 32.3 |
| Q1 | 41.9 |
| median | 60 |
| Q3 | 68.3 |
| 95-th percentile | 107.8 |
| Maximum | 134.1 |
| Range | 103.3 |
| Interquartile range (IQR) | 26.4 |
Descriptive statistics
| Standard deviation | 22.79190238 |
|---|---|
| Coefficient of variation (CV) | 0.3721985714 |
| Kurtosis | -0.003063006481 |
| Mean | 61.23586744 |
| Median Absolute Deviation (MAD) | 13.6 |
| Skewness | 0.809988664 |
| Sum | 4041138.6 |
| Variance | 519.4708141 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 34.3 | 1206 | 1.8% |
| 41.9 | 928 | 1.4% |
| 31.2 | 688 | 1.0% |
| 65.5 | 678 | 1.0% |
| 34.5 | 608 | 0.9% |
| 65.4 | 571 | 0.9% |
| 31.3 | 569 | 0.9% |
| 31.1 | 551 | 0.8% |
| 40.4 | 521 | 0.8% |
| 59.8 | 489 | 0.7% |
| Other values (975) | 59184 |
| Value | Count | Frequency (%) |
| 30.8 | 3 | < 0.1% |
| 30.9 | 163 | 0.2% |
| 31 | 427 | |
| 31.1 | 551 | |
| 31.2 | 688 | |
| 31.3 | 569 | |
| 31.4 | 184 | 0.3% |
| 31.5 | 224 | 0.3% |
| 31.6 | 83 | 0.1% |
| 31.7 | 53 | 0.1% |
| Value | Count | Frequency (%) |
| 134.1 | 4 | < 0.1% |
| 134 | 4 | < 0.1% |
| 133.9 | 7 | |
| 133.8 | 3 | < 0.1% |
| 133.7 | 3 | < 0.1% |
| 133.6 | 3 | < 0.1% |
| 133.5 | 4 | < 0.1% |
| 133.4 | 3 | < 0.1% |
| 133.3 | 1 | < 0.1% |
| 133.2 | 10 |
| Distinct | 92 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.63679481 |
| Minimum | 0 |
|---|---|
| Maximum | 96 |
| Zeros | 1133 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 13 |
| median | 25 |
| Q3 | 37 |
| 95-th percentile | 50 |
| Maximum | 96 |
| Range | 96 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 15.01363754 |
|---|---|
| Coefficient of variation (CV) | 0.5856284942 |
| Kurtosis | -0.6899789659 |
| Mean | 25.63679481 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 0.2165724409 |
| Sum | 1691849 |
| Variance | 225.4093123 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 31 | 1467 | 2.2% |
| 20 | 1455 | 2.2% |
| 16 | 1439 | 2.2% |
| 19 | 1434 | 2.2% |
| 25 | 1433 | 2.2% |
| 17 | 1423 | 2.2% |
| 24 | 1421 | 2.2% |
| 13 | 1411 | 2.1% |
| 27 | 1399 | 2.1% |
| 33 | 1396 | 2.1% |
| Other values (82) | 51715 |
| Value | Count | Frequency (%) |
| 0 | 1133 | |
| 1 | 1111 | |
| 2 | 1063 | |
| 3 | 996 | |
| 4 | 1132 | |
| 5 | 1185 | |
| 6 | 1112 | |
| 7 | 1064 | |
| 8 | 1218 | |
| 9 | 1264 |
| Value | Count | Frequency (%) |
| 96 | 5 | |
| 95 | 4 | |
| 94 | 2 | < 0.1% |
| 93 | 1 | < 0.1% |
| 92 | 3 | |
| 91 | 2 | < 0.1% |
| 90 | 2 | < 0.1% |
| 88 | 1 | < 0.1% |
| 84 | 2 | < 0.1% |
| 82 | 1 | < 0.1% |
| Distinct | 7399 |
|---|---|
| Distinct (%) | 11.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 137457.3483 |
| Minimum | 137084.5 |
|---|---|
| Maximum | 137825.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | 137084.5 |
|---|---|
| 5-th percentile | 137122.3 |
| Q1 | 137269.6 |
| median | 137454.5 |
| Q3 | 137648.5 |
| 95-th percentile | 137794.2 |
| Maximum | 137825.8 |
| Range | 741.3 |
| Interquartile range (IQR) | 378.9 |
Descriptive statistics
| Standard deviation | 218.6505279 |
|---|---|
| Coefficient of variation (CV) | 0.001590679077 |
| Kurtosis | -1.250089752 |
| Mean | 137457.3483 |
| Median Absolute Deviation (MAD) | 189.6 |
| Skewness | 0.01645967706 |
| Sum | 9071222789 |
| Variance | 47808.05336 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 137112.7 | 41 | 0.1% |
| 137820.9 | 34 | 0.1% |
| 137323.8 | 33 | 0.1% |
| 137766.4 | 32 | < 0.1% |
| 137725 | 31 | < 0.1% |
| 137467 | 31 | < 0.1% |
| 137481.7 | 31 | < 0.1% |
| 137730.3 | 31 | < 0.1% |
| 137628.3 | 31 | < 0.1% |
| 137306.8 | 30 | < 0.1% |
| Other values (7389) | 65668 |
| Value | Count | Frequency (%) |
| 137084.5 | 21 | |
| 137084.6 | 21 | |
| 137084.7 | 8 | < 0.1% |
| 137084.8 | 11 | |
| 137084.9 | 4 | < 0.1% |
| 137085 | 9 | |
| 137085.1 | 3 | < 0.1% |
| 137085.2 | 18 | |
| 137085.3 | 4 | < 0.1% |
| 137085.4 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 137825.8 | 5 | < 0.1% |
| 137825.7 | 12 | |
| 137825.6 | 11 | |
| 137825.5 | 12 | |
| 137825.4 | 15 | |
| 137825.3 | 27 | |
| 137825.2 | 7 | < 0.1% |
| 137825.1 | 9 | < 0.1% |
| 137825 | 8 | < 0.1% |
| 137824.9 | 4 | < 0.1% |
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 74.2822269 |
| Minimum | 66 |
|---|---|
| Maximum | 82 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | 66 |
|---|---|
| 5-th percentile | 68 |
| Q1 | 72 |
| median | 74 |
| Q3 | 77 |
| 95-th percentile | 80 |
| Maximum | 82 |
| Range | 16 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.588486517 |
|---|---|
| Coefficient of variation (CV) | 0.04830881715 |
| Kurtosis | -0.712787279 |
| Mean | 74.2822269 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | -0.03834976419 |
| Sum | 4902107 |
| Variance | 12.87723548 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 73 | 7072 | |
| 76 | 6314 | |
| 74 | 6188 | |
| 72 | 6006 | |
| 77 | 5530 | |
| 75 | 5173 | |
| 79 | 5088 | |
| 71 | 4858 | |
| 78 | 4629 | |
| 70 | 4216 | 6.4% |
| Other values (7) | 10919 |
| Value | Count | Frequency (%) |
| 66 | 580 | 0.9% |
| 67 | 1157 | 1.8% |
| 68 | 1645 | 2.5% |
| 69 | 3174 | |
| 70 | 4216 | |
| 71 | 4858 | |
| 72 | 6006 | |
| 73 | 7072 | |
| 74 | 6188 | |
| 75 | 5173 |
| Value | Count | Frequency (%) |
| 82 | 775 | 1.2% |
| 81 | 1551 | 2.4% |
| 80 | 2037 | 3.1% |
| 79 | 5088 | |
| 78 | 4629 | |
| 77 | 5530 | |
| 76 | 6314 | |
| 75 | 5173 | |
| 74 | 6188 | |
| 73 | 7072 |
Acceleration
Real number (ℝ)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 1026 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.06658503531 |
| Minimum | -3.888888889 |
|---|---|
| Maximum | 3.055555556 |
| Zeros | 879 |
| Zeros (%) | 1.3% |
| Negative | 32853 |
| Negative (%) | 49.8% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | -3.888888889 |
|---|---|
| 5-th percentile | -1.388888889 |
| Q1 | -0.8333333334 |
| median | 0 |
| Q3 | 0.5555555556 |
| 95-th percentile | 1.388888889 |
| Maximum | 3.055555556 |
| Range | 6.944444445 |
| Interquartile range (IQR) | 1.388888889 |
Descriptive statistics
| Standard deviation | 0.8869403167 |
|---|---|
| Coefficient of variation (CV) | -13.3204152 |
| Kurtosis | -0.1393279901 |
| Mean | -0.06658503531 |
| Median Absolute Deviation (MAD) | 0.5555555556 |
| Skewness | -0.09272746877 |
| Sum | -4394.146235 |
| Variance | 0.7866631254 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.2777777778 | 7223 | |
| -0.2777777778 | 6321 | 9.6% |
| 0.5555555556 | 5931 | 9.0% |
| -0.8333333334 | 5817 | 8.8% |
| -0.5555555556 | 5802 | 8.8% |
| 0.8333333334 | 4718 | 7.1% |
| -1.111111111 | 4586 | 6.9% |
| 1.111111111 | 3352 | 5.1% |
| -1.388888889 | 2373 | 3.6% |
| 1.388888889 | 1962 | 3.0% |
| Other values (1016) | 17908 |
| Value | Count | Frequency (%) |
| -3.888888889 | 3 | < 0.1% |
| -3.611111111 | 6 | < 0.1% |
| -3.333333334 | 9 | < 0.1% |
| -3.055555556 | 33 | |
| -2.916666667 | 1 | < 0.1% |
| -2.870370371 | 1 | < 0.1% |
| -2.777777778 | 71 | |
| -2.685185185 | 1 | < 0.1% |
| -2.638888889 | 3 | < 0.1% |
| -2.569444445 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3.055555556 | 7 | < 0.1% |
| 2.916666667 | 1 | < 0.1% |
| 2.777777778 | 18 | < 0.1% |
| 2.638888889 | 1 | < 0.1% |
| 2.5 | 96 | 0.1% |
| 2.407407408 | 2 | < 0.1% |
| 2.361111111 | 3 | < 0.1% |
| 2.314814815 | 2 | < 0.1% |
| 2.222222222 | 240 | |
| 2.12962963 | 3 | < 0.1% |
| Distinct | 215 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.05150544606 |
| Minimum | -6.5983104 |
|---|---|
| Maximum | 11.00791296 |
| Zeros | 221 |
| Zeros (%) | 0.3% |
| Negative | 14254 |
| Negative (%) | 21.6% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | -6.5983104 |
|---|---|
| 5-th percentile | -0.804672 |
| Q1 | 0.09656064 |
| median | 0.09656064 |
| Q3 | 0.09656064 |
| 95-th percentile | 0.83685888 |
| Maximum | 11.00791296 |
| Range | 17.60622336 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.813591808 |
|---|---|
| Coefficient of variation (CV) | 15.79622875 |
| Kurtosis | 65.27242703 |
| Mean | 0.05150544606 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.301082056 |
| Sum | 3398.998902 |
| Variance | 0.66193163 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.09656064 | 37300 | |
| -0.38624256 | 997 | 1.5% |
| -0.4828032 | 888 | 1.3% |
| -0.41842944 | 766 | 1.2% |
| 0.6437376 | 702 | 1.1% |
| -0.3218688 | 638 | 1.0% |
| 0.3218688 | 504 | 0.8% |
| 0.19312128 | 490 | 0.7% |
| 0.804672 | 480 | 0.7% |
| -0.45061632 | 447 | 0.7% |
| Other values (205) | 22781 |
| Value | Count | Frequency (%) |
| -6.5983104 | 61 | |
| -6.2764416 | 44 | |
| -6.21206784 | 66 | |
| -5.66489088 | 26 | < 0.1% |
| -4.89240576 | 38 | |
| -4.53835008 | 41 | |
| -4.37741568 | 42 | |
| -3.44399616 | 60 | |
| -3.28306176 | 40 | |
| -3.02556672 | 63 |
| Value | Count | Frequency (%) |
| 11.00791296 | 58 | |
| 10.55729664 | 52 | |
| 5.72926464 | 28 | |
| 4.73147136 | 56 | |
| 3.44399616 | 57 | |
| 3.25087488 | 31 | |
| 3.18650112 | 56 | |
| 3.12212736 | 48 | |
| 2.86463232 | 17 | < 0.1% |
| 2.83244544 | 26 |
| Distinct | 215 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.02948507043 |
| Minimum | -3.775081113 |
|---|---|
| Maximum | 6.28177804 |
| Zeros | 221 |
| Zeros (%) | 0.3% |
| Negative | 14254 |
| Negative (%) | 21.6% |
| Memory size | 515.7 KiB |
Quantile statistics
| Minimum | -3.775081113 |
|---|---|
| 5-th percentile | -0.4610331445 |
| Q1 | 0.0553251542 |
| median | 0.0553251542 |
| Q3 | 0.0553251542 |
| 95-th percentile | 0.4794736259 |
| Maximum | 6.28177804 |
| Range | 10.05685915 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.465451619 |
|---|---|
| Coefficient of variation (CV) | 15.78601008 |
| Kurtosis | 64.8206058 |
| Mean | 0.02948507043 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.272306661 |
| Sum | 1945.808253 |
| Variance | 0.2166452097 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.0553251542 | 37300 | |
| -0.2212995851 | 997 | 1.5% |
| -0.2766237076 | 888 | 1.3% |
| -0.2397410102 | 766 | 1.2% |
| 0.3688293813 | 702 | 1.1% |
| -0.1844166011 | 638 | 1.0% |
| 0.1844166011 | 504 | 0.8% |
| 0.1106502052 | 490 | 0.7% |
| 0.4610331445 | 480 | 0.7% |
| -0.2581823857 | 447 | 0.7% |
| Other values (205) | 22781 |
| Value | Count | Frequency (%) |
| -3.775081113 | 61 | |
| -3.591425098 | 44 | |
| -3.554684904 | 66 | |
| -3.242278088 | 26 | < 0.1% |
| -2.800908724 | 38 | |
| -2.598500023 | 41 | |
| -2.506474304 | 42 | |
| -1.972484831 | 60 | |
| -1.880380432 | 40 | |
| -1.732993369 | 63 |
| Value | Count | Frequency (%) |
| 6.28177804 | 58 | |
| 6.026561582 | 52 | |
| 3.27904221 | 28 | |
| 2.708913138 | 56 | |
| 1.972484831 | 57 | |
| 1.861958371 | 31 | |
| 1.825113096 | 56 | |
| 1.788266311 | 48 | |
| 1.640864678 | 17 | < 0.1% |
| 1.622437907 | 26 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| Friday | |
|---|---|
| Thursday | |
| Monday | |
| Wednesday | |
| Tuesday |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.182049611 |
| Min length | 6 |
Characters and Unicode
| Total characters | 473965 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Monday |
|---|---|
| 2nd row | Monday |
| 3rd row | Monday |
| 4th row | Monday |
| 5th row | Monday |
Common Values
| Value | Count | Frequency (%) |
| Friday | 14199 | |
| Thursday | 13765 | |
| Monday | 12850 | |
| Wednesday | 12649 | |
| Tuesday | 12530 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| friday | 14199 | |
| thursday | 13765 | |
| monday | 12850 | |
| wednesday | 12649 | |
| tuesday | 12530 |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 78642 | |
| a | 65993 | |
| y | 65993 | |
| s | 38944 | |
| e | 37828 | |
| r | 27964 | 5.9% |
| T | 26295 | 5.5% |
| u | 26295 | 5.5% |
| n | 25499 | 5.4% |
| F | 14199 | 3.0% |
| Other values (5) | 66313 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 407972 | |
| Uppercase Letter | 65993 | 13.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 78642 | |
| a | 65993 | |
| y | 65993 | |
| s | 38944 | |
| e | 37828 | |
| r | 27964 | 6.9% |
| u | 26295 | 6.4% |
| n | 25499 | 6.3% |
| i | 14199 | 3.5% |
| h | 13765 | 3.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 26295 | |
| F | 14199 | |
| M | 12850 | |
| W | 12649 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 473965 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 78642 | |
| a | 65993 | |
| y | 65993 | |
| s | 38944 | |
| e | 37828 | |
| r | 27964 | 5.9% |
| T | 26295 | 5.5% |
| u | 26295 | 5.5% |
| n | 25499 | 5.4% |
| F | 14199 | 3.0% |
| Other values (5) | 66313 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 473965 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 78642 | |
| a | 65993 | |
| y | 65993 | |
| s | 38944 | |
| e | 37828 | |
| r | 27964 | 5.9% |
| T | 26295 | 5.5% |
| u | 26295 | 5.5% |
| n | 25499 | 5.4% |
| F | 14199 | 3.0% |
| Other values (5) | 66313 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| DateTime | Current | Voltage | Power | Elevation | Speed | Odometer | Temperature | Acceleration | Grade | Angle | Day | Hour | 30Min | 1Min | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2020-08-03 08:56:49 | 25.8 | 515 | 13.2870 | 68.7 | 11 | 137084.5 | 75.0 | 0.000000 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:56 | 2020-08-03 08:56 |
| 1 | 2020-08-03 08:56:50 | -5.2 | 516 | -2.6832 | 68.7 | 9 | 137084.5 | 75.0 | -0.555556 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:56 | 2020-08-03 08:56 |
| 2 | 2020-08-03 08:56:53 | 1.8 | 515 | 0.9270 | 68.7 | 7 | 137084.5 | 75.0 | -0.185185 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:56 | 2020-08-03 08:56 |
| 3 | 2020-08-03 08:56:58 | 27.0 | 514 | 13.8780 | 68.7 | 9 | 137084.5 | 76.0 | 0.111111 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:56 | 2020-08-03 08:56 |
| 4 | 2020-08-03 08:57:02 | 14.4 | 515 | 7.4160 | 68.6 | 8 | 137084.5 | 76.0 | -0.069444 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:57 | 2020-08-03 08:57 |
| 5 | 2020-08-03 08:57:03 | -5.3 | 514 | -2.7242 | 68.6 | 7 | 137084.5 | 76.0 | -0.277778 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:57 | 2020-08-03 08:57 |
| 6 | 2020-08-03 08:57:05 | -3.0 | 516 | -1.5480 | 68.6 | 5 | 137084.5 | 76.0 | -0.277778 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:57 | 2020-08-03 08:57 |
| 7 | 2020-08-03 08:57:06 | 18.2 | 515 | 9.3730 | 68.5 | 4 | 137084.5 | 76.0 | -0.277778 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:57 | 2020-08-03 08:57 |
| 8 | 2020-08-03 08:57:08 | 23.4 | 514 | 12.0276 | 68.5 | 5 | 137084.5 | 76.0 | 0.138889 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:57 | 2020-08-03 08:57 |
| 9 | 2020-08-03 08:57:17 | 12.8 | 516 | 6.6048 | 68.5 | 7 | 137084.5 | 76.0 | 0.061728 | 0.257495 | 0.147533 | Monday | 2020-08-03 08:00 | 2020-08-03 08:57 | 2020-08-03 08:57 |
Last rows
| DateTime | Current | Voltage | Power | Elevation | Speed | Odometer | Temperature | Acceleration | Grade | Angle | Day | Hour | 30Min | 1Min | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65983 | 2020-08-07 22:03:16 | 10.2 | 494 | 5.0388 | 68.5 | 9 | 137825.7 | 73.0 | -0.277778 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65984 | 2020-08-07 22:03:22 | 33.4 | 493 | 16.4662 | 68.6 | 6 | 137825.7 | 73.0 | -0.138889 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65985 | 2020-08-07 22:03:23 | 34.9 | 493 | 17.2057 | 68.7 | 7 | 137825.7 | 73.0 | 0.277778 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65986 | 2020-08-07 22:03:29 | 6.5 | 494 | 3.2110 | 68.7 | 9 | 137825.7 | 73.0 | 0.092593 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65987 | 2020-08-07 22:03:46 | 18.7 | 493 | 9.2191 | 68.6 | 9 | 137825.7 | 73.0 | 0.000000 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65988 | 2020-08-07 22:03:51 | 35.6 | 493 | 17.5508 | 68.5 | 10 | 137825.8 | 73.0 | 0.055556 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65989 | 2020-08-07 22:03:52 | 36.6 | 492 | 18.0072 | 68.5 | 11 | 137825.8 | 73.0 | 0.277778 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65990 | 2020-08-07 22:03:53 | -29.2 | 494 | -14.4248 | 68.5 | 9 | 137825.8 | 73.0 | -0.555556 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65991 | 2020-08-07 22:03:54 | 18.5 | 494 | 9.1390 | 68.5 | 8 | 137825.8 | 73.0 | -0.277778 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |
| 65992 | 2020-08-07 22:03:59 | -21.9 | 494 | -10.8186 | 68.4 | 8 | 137825.8 | 73.0 | 0.000000 | 0.096561 | 0.055325 | Friday | 2020-08-07 22:00 | 2020-08-07 22:03 | 2020-08-07 22:03 |